Show AllShow All

TTEST

See Also

Returns the probability associated with a Student's t-Test. Use TTEST to determine whether two samples are likely to have come from the same two underlying populations that have the same mean.

Syntax

TTEST(array1,array2,tails,type)

Array1    is the first data set.

Array2    is the second data set.

Tails    specifies the number of distribution tails. If tails = 1, TTEST uses the one-tailed distribution. If tails = 2, TTEST uses the two-tailed distribution.

Type    is the kind of t-Test to perform.

If type equals This test is performed
1 Paired
2 Two-sample equal variance (homoscedastic)
3 Two-sample unequal variance (heteroscedastic)

Remarks

Example

The example may be easier to understand if you copy it to a blank worksheet.

ShowHow?

 
1
2
3
4
5
6
7
8
9
10
A B
Data 1 Data 2
3 6
4 19
5 3
8 2
9 14
1 4
2 5
4 17
5 1
Formula Description (Result)
=TTEST(A2:A10,B2:B10,2,1) Probability associated with a Student's paired t-Test, with a two-tailed distribution (0.196016)